Show All
Filter a field in a chart
Filter a field in the category, series, or filter area (autofiltering)
If the filter area does not have a field, you can either add a new field or move a field from another area to the filter area.
- Click the arrow
for the field that contains the items of data that you want to filter.
- Select the check boxes for the items you want to display, and clear the check boxes for the items you want to hide.
Notes
- To display or hide all of the data for a field, select or clear the (All) check box. A shaded check box indicates that some items are hidden.
- When placed in the category, series, or filter area, a field always supports multiple selection. A field in the filter area can support either single or multiple selection.
Filter a series or point for the top or bottom n values, or for a percentage (conditional filtering)
- Select the series or point that has the values you want to filter.
- On the toolbar, click Show Top/Bottom Items
. - Point to Show Only the Top or Show Only the Bottom, and then click the number or percentage you want.
Note When items in a field are hidden by an autofilter, the arrow
in the field label is blue.